{literal}
<style type="text/css">
	div.block { font-family:Verdana; margin:0 3px 3px 0; background-color:lightblue; padding:5px; font-size:12px; color:black; border: 1px dotted grey }
	div.block h2 {font-size:15px; font-weight:bold; }
	
	div.row1 {float:left; width:400px;}
	div.row2 {float:left; width:400px;}
</style>

<div class="row1">
<div class="block" style="background-color: #EDE7FE">
<h2>Class annotations</h2>
@orm <b>tableName</b> $tablename<br>
@orm <b>database</b> $database<br>
@orm <b>engine</b> InnoDB|MyIsam<br>
@orm <b>index</b>(args)|<b>unique</b>(args)<br>
@orm <b>listener</b> $type $method()<br>
</div>

<div class="block" style="background-color:#E9FDE8">
<h2>Method annotations</h2>
@orm <b>access</b>
</div>

<div class="block" style="background-color:#F5F4CD">

<h2>Listener methods</h2>
<b>beforeValidate</b>( &$value, $AnnoArg1 ){return $value;}<br>
<b>beforeSet</b>( &$value, $AnnoArg1 ) {return $value;}<br>
<b>afterSet</b>( $AnnoArg1 ) {}<br>

<h2>Validator methods</h2>
public function myValidator( &$value, $AnnoArg1 ) {return 0;}<br>

$object-><b>getValidationErrorMessages()</b>;<br>
$object-><b>getValidationMessages($separator)</b>;<br>
$object-><b>getLastValidationMessage()</b>;<br>

<h2>Validators</h2>
>, >=, <, <=, <> NotIn, In, length,
</div>

<div class="block">
<h2> 1:N, N:M Relationship listener methods</h2>
<b>beforeAdd</b>( Object $object ) {}<br>
<b>afterAdd</b>( Object $object ) {}<br>
<b>beforeRemove</b>( Object $object ) {}<br>
<b>afterRemove</b>( Object $object ) {}<br>
<h2> 1:N, N:M Relationship validator</h2>
<b>myValidationMethod( Object $object) {return 0;}</b>
</div>

</div>

<div class="row2">
<div class="block" style="background-color:#FFE6E6">
<h2>Property annotations</h2>
@orm <b>text|longtext</b> [not null] [fulltext]<br>
@orm <b>bool|boolean</b> [not null] [index]<br>
@orm <b>char</b>($l)|<b>varchar</b>($l) [not null] [unique|index|fulltext]<br>
@orm <b>number</b>($l,$d) [in()] [unique|index] [unsigned] [not null]<br>
@orm <b>array</b><br>
@orm <b>email</b> [unique|index]<br>
@orm <b>password</b>($l,$m)<br>
<br>
@orm <b>plugin</b> $plugin()<br>
@orm <b>has|owns</b> one|child|parent $className [inverse $inverse]<br>
@orm <b>has|owns</b> many|children|parents $className [inverse $inverse] [itemValidator $itemValidator()] [counter $counter]<br>
@orm <b>order</b> property_name<br>
<br>
@orm <b>listener</b> $type [method] $method()<br>
@orm <b>validator</b> [method] $validator()<br>
</div>




<div class="block" style="background-color:#CBF9CA">
<h2>Queries</h2>
DomSql::<b>query</b>('QUERY');<br>
DomSql::<b>selectQuery</b>('SELECT QUERY');<br>
DomSql::<b>selectOneQuery</b>('SELECT n FROM t', 'n');<br>
DomSql::<b>keyListQuery</b>('SELECT n1, n2 FROM t', 'n1', 'n2');<br>
<br>
ClassName::<b>query</b>()->commit();<br>
ClassName::<b>idSetQuery</b>( $column )->commit();<br>
ClassName::<b>dataQuery</b>()->commit();<br>
<br>
Query-><b>select</b>(f)-><b>distinct</b>()-><b>from</b>(t,n)-><b>join</b>(t,n,c)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-><b>leftJoin</b>(t,n,c)-><b>where</b>(w)-><b>countFoundRows</b>()
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-><b>groupBy</b>(g)-><b>having</b>(h)-><b>orderBy</b>(o)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-><b>matchAgainst</b>(m,a);
<br>
<br>
$result = $query->countFoundRows()->commit();<br>
$count = $query->foundRows();<br>
$resultAsArray = $result->toArray();<br>
</div>


</div>
{/literal}